Create KPI 's and YOY Arrow 13

Step 1: Create Accident Per Day KPI


1.   Double click on the Card Icon on the visualization bar.

2.   Card visual will display on the report

3.   Drag and drop the "Accident Per Day " column from the DUI_Fatalities table 

4.   Configure the Format Accident Per Day KPI

          Click on the Format icon on the visualization bar

a.    Click General Tab:

·         X- Position 0

·         Y Position:  216

·         Width: 180

·         Height: 100

·         Categories: Off

b.    Data Label:

·         Text size: 30  

·         Font Family: Tacoma

c.     Title: ON

·         Type: “Accident Per Day”

·         Font color: Black

·         Background:  

·         Color: ACDOE7

·         Text Size: 17

·         Font Family: DIN

·         Background: White (FFFFF)

·         Transparency: 15%

d.    Boarder ON

               ·         Boarder Color: White, 10% darker    


Follow the gif below to create Accident Per Day KPI 


 

Step 2:  Create % Fatalities KPI

1.    Repeat Step 1 (1 to 3 steps) to create % Fatalities KPI.

2.    Configure the Format %Fatalities

     

Click on the Format icon on the visualization bar

a.    Click General Tab:

·         X- Position 0

·         Y Position:  213

·         Width: 180

·         Height: 107

·         Categories: Off

b.    Data Label:

·         Text size: 30  

·         Font Family: Trebuchet MS

c.     Title: ON

·         Type: “%Fatalities”

·         Font color: Black

d.    Background:  

·         Color: ACDOE7

·         Text Size: 17

·         Font Family: DIN Background: White (FFFFF)

·         Transparency: 15%

·         Boarder ON

·         Boarder Color: Color: White, 10% darker  

Step 3: Create YOY KPI

    

1.   Double click on the Card icon on the visualization bar

2.   Card visual will display on the report

3.   Drag and drop the "YOY " column from the DUI_Fatalities table

4.   Configure the Format YOY KPI

      

Click on the Format icon on the visualization bar

a.    Click General Tab:

·         X- Position 0

·         Y Position:  320

·         Width: 180

·         Height: 110

·         Categories: Off

b.    Data Label:

·      Color: Click (fx)

·         Color formatted by: Select “Color Scale”

·         Based on Field: Select “YOY”

·         Minimum Custom color: 0B9A0E

·         Custom: 0

·         Maximum Custom color: EB5559

·         Custom: 0

·         Text size: 30  

·         Font Family: Tahoma

c.     Title: ON

·         Type: “YOY”

·         Font color: Black

·         Background:  

·         Color: ACDOE7

·         Text Size: 17

·         Font Family: DIN

·         Background: White (FFFFF)

·         Transparency: 15%

d.    Boarder ON

                                                    ·         Boarder Color: White, 10% darker  


Follow the gif below to create YOY KPI 


Step 4: Create YOY KPI Arrow

    

1.   Double click on the Card Icon on the visualization bar.

2.   Card visual will display on the report

3.   Drag and drop the "Arrow YOY" column from the DUI_Fatalities

4.   Configure the Format YOY KPI Arrow

       

 Click on the Format icon on the visualization bar

                              a. Click General Tab:

·         X- Position 0

·         Y Position:  347

·         Width: 39

·         Height: 76

·         Categories: Off

                              b. Data Label:

·      Color: Click (fx)

·         Color format by: Select “Field Value” from the list

·         Based on Field: Select from the list DUI _Fatalities table “Color Arrow YOY” Column

·         Text size: 18  

·         Background: ACD0E7

·         Transparency: 96%

c.     Boarder OFF


Follow the gif below to create YOY KPI Arrow 


To learn more about how to create KPI Cards and Indicators in Power BI, click the link below.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi